package com.example.novelstory.dao.dxy;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.novelstory.entity.VipUser;
import org.apache.ibatis.annotations.Mapper;

@Mapper //Dao层的注解

public interface VipDao extends BaseMapper<VipUser> {
//    @Select("select * from vipuser")
//    public List<VipUser> findVipAll();
//
//    @Insert("INSERT INTO vipuser(username, password, email, sex, introduce, province,city,country,headimgurl,status,login,login_ip,login_time,exp,intrgral,create_time,update_time,recommend,viplevel,recharge) VALUES(#{username,jdbcType=VARCHAR},#{email,jdbcType=VARCHAR},#{password,jdbcType=VARCHAR},#{sex,jdbcType=VARCHAR},#{province,jdbcType=VARCHAR},#{city,jdbcType=VARCHAR},#{country,jdbcType=VARCHAR},#{headimgurl,jdbcType=VARCHAR},#{introduce,jdbcType=VARCHAR},#{status,jdbcType=VARCHAR},#{login,jdbcType=VARCHAR},#{login_ip,jdbcType=VARCHAR},#{login_time,jdbcType=VARCHAR},#{exp,jdbcType=VARCHAR},#{integral,jdbcType=VARCHAR},#{create_time,jdbcType=VARCHAR},#{update_time,jdbcType=VARCHAR},#{recommend,jdbcType=VARCHAR},#{viplevel,jdbcType=VARCHAR},#{recharge,jdbcType=VARCHAR})")
//    public int addVipInfo(@Param("username") String username, @Param("password") String password, @Param("email") String email, @Param("sex") int sex, @Param("introduce") String introduce, @Param("province") String province, @Param("city") String city, @Param("country") String country, @Param("headimgurl") String headimgurl, @Param("status") String status, @Param("login") int login, @Param("login_ip") String login_ip, @Param("login_time") int login_time, @Param("exp") int exp, @Param("integral") int integral, @Param("create_time") int create_time, @Param("update_time") int update_time, @Param("recommend") String recommend, @Param("viplevel") int viplevel, @Param("recharge") int recharge);
//
//    @Delete("DELETE FROM vipuser WHERE id=#{id,jdbcType=VARCHAR}")
//    public int deleteVipInfo(int id);
//
//    @Update("UPDATE vipuser SET password=#{password,jdbcType=VARCHAR},email=#{email,jdbcType=VARCHAR},sex=#{sex,jdbcType=VARCHAR},introduce=#{introduce,jdbcType=VARCHAR},province=#{province,jdbcType=VARCHAR},city=#{city,jdbcType=VARCHAR},country=#{country,jdbcType=VARCHAR},headimgurl=#{headimgurl,jdbcType=VARCHAR},status=#{status,jdbcType=VARCHAR},login=#{login,jdbcType=VARCHAR},login_ip=#{login_ip,jdbcType=VARCHAR},login_time=#{login_time,jdbcType=VARCHAR},exp=#{exp,jdbcType=VARCHAR},integral=#{integral,jdbcType=VARCHAR},create_time=#{create_time,jdbcType=VARCHAR},update_time=#{update_time,jdbcType=VARCHAR},recommend=#{recommend,jdbcType=VARCHAR},viplevel=#{viplevel,jdbcType=VARCHAR},recharge=#{recharge,jdbcType=VARCHAR} WHERE username=#{username,jdbcType=VARCHAR}")
//    public int updeteVipInfo(@Param("username") String username, @Param("password") String password, @Param("email") String email, @Param("sex") int sex, @Param("introduce") String introduce, @Param("province") String province, @Param("city") String city, @Param("country") String country, @Param("headimgurl") String headimgurl, @Param("status") String status, @Param("login") int login, @Param("login_ip") String login_ip, @Param("login_time") int login_time, @Param("exp") int exp, @Param("integral") int integral, @Param("create_time") int create_time, @Param("update_time") int update_time, @Param("recommend") String recommend, @Param("viplevel") int viplevel, @Param("recharge") int recharge);

}
